USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MatchPlayerListInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.MatchPlayerListInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/05/08
-- Description:	MatchPlayerList Table Insert
-- =============================================
CREATE PROCEDURE MatchPlayerListInsert

           @MatchPlayerListId int
           ,@MatchId int
           ,@PlayerId varchar(30)
           ,@TeamId int
AS
BEGIN

INSERT INTO [AnotherSuccessfulProcedure].[dbo].[MatchPlayerList]
           ([MatchPlayerListId]
           ,[MatchId]
           ,[PlayerId]
           ,[TeamId])
     VALUES
           (@MatchPlayerListId
           ,@MatchId
           ,@PlayerId
           ,@TeamId)

END
GO
